package com.example.teachingSystem.mapper;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.teachingSystem.pojo.entity.Score;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.teachingSystem.pojo.entity.SysUser;
import com.example.teachingSystem.pojo.form.score.AddScoreForm;
import com.example.teachingSystem.pojo.form.score.ScorePageQuery;
import com.example.teachingSystem.pojo.form.score.UpdateScoreForm;
import com.example.teachingSystem.pojo.vo.ScoreInfoVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
* @author 86147
* @description 针对表【score(成绩表)】的数据库操作Mapper
* @createDate 2023-11-27 21:43:54
* @Entity com.example.teachingSystem.pojo.entity.Score
*/
@Mapper
public interface ScoreMapper extends BaseMapper<Score> {
    Page<ScoreInfoVo> showScoresByTeacher(Page<Score> page, ScorePageQuery scorePageQuery);

    Page<ScoreInfoVo> showScoresByStudent(Page<Score> page,ScorePageQuery scorePageQuery);

    Page<ScoreInfoVo> showScoresByAdmin(Page<Score> page,ScorePageQuery scorePageQuery);

    void deleteScoreByScoreId(Long scoreId);

}




